EMT Practice Test

1. Question Content...

---

Question1: How can you change the Default Aggregation for a measure in Tableau?

Question2: Which of the following are required to create a trend line?

Question3: Is SUM a table calculation?

Question4: ________________ can only create header. _______________ will create header and axis both.

Question5: If you see a Blue field, generally it will add _____________ to the view

Question6: We can use ______________ as a static tool to open and interact with packaged workbooks with extracted data sources that have been created in Tableau Desktop.

Question7: Which of the following are valid ways to export a dashboard with multiple visualisations as an image?

Question8: If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can __________________ the view.

Question9: What is the following icon in the Data pane used to do?
Larger image

Question10: Which of the following URL prefixes are permitted when creating a URL Action in Tableau?

Question11: You can _______________ your data to combine two or more tables by appending values (rows) from one table to another

Question12: Which of the following are valid ways of Grouping Data?

Question13: Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?
Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?

Question14: Which of the following are valid ways to show Mark Labels in the visualisation?

Question15: True or False: When you drag additional tables to the logical layer canvas, Tableau automatically attempts to create the relationship based on existing key constraints and matching fields to define the relationship. If it can't determine the matching fields, then relating these tables is not possible.

Question16: Suppose you create a bar chart by dragging a dimension to the Column shelf and a measure to the Rows shelf. Which of the following would create a stacked bar chart?

Question17: Which of the following options best describe measures?

Question18: You can use the __________________ in Tableau to clean / organise your data.

Question19: For creating variable sized bins we use __________________

Question20: True or False: The Highlighting action can be disabled for the entire workbook.

Question21: _________________ are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.

Question22: The calculation [Ship Date] - [Order Date] will return _______________

Question23: Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us

Question24: The View Data window displays as much of the data as possible by default, up to _______________ rows.

Question25: Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?

Question26: Which of the following points are True about Viz Animations?

Question27: Which of the following are valid ways to add Totals to a view?

Question28: True or False: To concatenate fields, they must be of same data type

Question29: What is a story point in Tableau?

Question30: Which of the following is a benefit of using a Tableau Data Source (.tds)?

Question31: Using the Time Series table, create a chart that shows the percent difference in Average Inventory on Hand for each Assortment by year and quarter.
How many quarters did the Electronics Assortment show a negative percent difference in the Average Inventory On Hand?

Question32: When you want to first apply a filter and THEN show the Top N or Bottom N elements, which of the following filters would you use?

Question33: Which of the following are true about dimensions?

Question34: You just added this field to the Columns shelf.

What will this create?

Question35: Which of the following are stored in a .tds file? Choose 3.

Question36: Yes or No: The number of marks will increase when you increase the number of Dimensions in a view

Question37: If you see the following Filter, then you're working with _______________________ Larger image

Question38: In order to avoid any confusions, what should you do after creating a Dual-axis chart?

Question39: Which of the following is a compelling reason to export a sheet in Tableau to a PDF?

Question40: A Tableau Data Source File (.tds) contains which of the following?

Question41: ________________ is hosted by Tableau to share our visualisations publically with the world.

Question42: Is it possible to make a Measure discrete?

Question43: Download the Dataset from: https://drive.google.com/file/d/12AYHfiPWkwBmvH0zbumOURgUX6Az00Rw/view?usp=sharing Using the Time Series Table, create a line chart to show Sales over time. Which Month and Year witnessed the lowest Sales?

Question44: When there are both negative and positive values for a field, the default range of values will use two color ranges. This is known as a ______________ palette.

Question45: True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.

Question46: Which of the following 2 fields CANNOT be deleted in Tableau?

Question47: True or False: Tableau can create worksheet-specific filters

Question48: Using the cwurData table, create a cross-tab showing the number of Publications per Country broken down by Institution, and filtered by Country to only show United Kingdown (UK). For the University of Manchester, what percent of the total publications were contributed in 2014?

Question49: Which of the following returns the Absolute Value of a given number?

Question50: ______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.

Question51: Which of the following represent a valid method to create a Bullet Graph with the LEAST number of fields possible?

Question52: Using the CoffeeChain table, create a Dual Axis chart showing the Sales (Bar chart) and Profit (Line Chart) for each Product type. What was the Profit for the Herbal Tea product type in 2013?

Question53: Question 45: Skipped
You have just created a histogram and now want to be able to change the size of bins dynamically. Using which of the following will easily satisfy your requirement?

Question54:

Question55: For a relative date filter, the default anchor is _________________

Question56: Using the Time Series table, create a cross-tab showing sales for each Assortment broken down by Year and Quarter. In Q4 of October 2017, what was the Average sales amount for the Hardware assortment?

Question57: When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors.

Question58: Are animations enabled by default in Tableau?

Question59: Which of the following is a good reason for using a bullet graph?

Question60: How can you change the default Tableau repository location?

Question61: Given a map, which of the following fields can be placed in Size,Shape,Detail,Color

Question62: True or False: When relating tables, the fields that define the relationships must have the same data type.

Question63: True or False: Enabling any other type of sort (Field, alphabetic, or Nested) clears the manual sort we create.

Question64: True or False : Bins can be created on dimensions

Question65: Which of the following 2 columns CANNOT be deleted in Tableau?

Question66: Which of the following is true about 'Incremental refresh' when creating Extracts in Tableau?

Question67: Which of the following would you use to edit the Shape, colour, and Text of your visualisations?

Question68: Which of the following is NOT a new feature introduced in Tableau 2020.1?

Question69: By definition, Tableau displays measures over time as a ____________

Question70: Which of the following chart type makes use of 'binned' data?

Question71: ______________ refers to the level of detail for a piece of data, wherever you are looking.

Question72: Which of the following charts types always includes bars sorted in descending order?

Question73: Which of the following can you use to create a Histogram?

Question74: Which of the following are compelling reasons to use a Stacked Bar Chart?

Question75: True or False: It is possible to add a field to more than one hierarchy

Question76: Which of the following shapes does a Heat Map use by default?

Question77: Using the dataset provided, create a crosstab showing the Profit of each Region per Year, then add grand totals to the view. What was the total Profit for Canada in 2012 and the total Profit for Canada for 2011 through 2014, respectively?

Question78: When working with Excel, text file data, JSON file, .pdf file data, you can use _________________ to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection.

Question79: For which of the following charts, does the Size option on the Marks card not work?

Question80: Most viewers scan content starting at the _____________ of a page.